﻿<HTML>
<HEAD>
<META http-equiv="content-type" content="text/html; charset=UTF-8">
 <Title>Export Data</Title>
<Style type="text/css">
  BODY { background: #317676; color: #FFFFFF;
         font-family: Arial;
  }
  A:link { color: #FFE760 }
  A:visited { color: #CCCC39 }
  A:active { color: #FFFF00 }
  .ThRows { 
            background-color: #3A9393;
            color: #FFFFFF;
            font-weight: bold; text-align: center;
            font-family: Arial;
  }
  .TrRows {
            background-color: #276262;
            color: #FFE760;
            font-family: Arial;
  }
  .TrOdd  {
            background-color: #367800;
            color: #FFE760;
            font-family: Arial;
  }
</STYLE>
</HEAD>
<BODY>
<Table Border="1" Cellpadding="4" Cellspacing="1">
  <tr>
    <td class="ThRows">表名</td>
    <td class="ThRows">字段名</td>
    <td class="ThRows">字段类型</td>
    <td class="ThRows">默认值</td>
    <td class="ThRows">能否为空</td>
    <td class="ThRows">备注</td>
  </tr>
  <tr>
    <td class="TrOdd" align=Left>Route</td>
    <td class="TrOdd" align=Left>RouteID</td>
    <td class="TrOdd" align=Left>int</td>
    <td class="TrOdd" align=Left>null</td>
    <td class="TrOdd" align=Left>N</td>
    <td class="TrOdd" align=Left>路线唯一标识</td>
  </tr>
  <tr>
    <td class="TrRows" align=Left>Route</td>
    <td class="TrRows" align=Left>CountMile</td>
    <td class="TrRows" align=Left>int</td>
    <td class="TrRows" align=Left>null</td>
    <td class="TrRows" align=Left>Y</td>
    <td class="TrRows" align=Left>里程</td>
  </tr>
  <tr>
    <td class="TrOdd" align=Left>Route</td>
    <td class="TrOdd" align=Left>CreateOn</td>
    <td class="TrOdd" align=Left>datetime</td>
    <td class="TrOdd" align=Left>(getdate())</td>
    <td class="TrOdd" align=Left>Y</td>
    <td class="TrOdd" align=Left>创建时间</td>
  </tr>
  <tr>
    <td class="TrRows" align=Left>Route</td>
    <td class="TrRows" align=Left>TrainNumber</td>
    <td class="TrRows" align=Left>varchar(50)</td>
    <td class="TrRows" align=Left>null</td>
    <td class="TrRows" align=Left>N</td>
    <td class="TrRows" align=Left>车次</td>
  </tr>
  <tr>
    <td class="TrOdd" align=Left>Route</td>
    <td class="TrOdd" align=Left>Countimes</td>
    <td class="TrOdd" align=Left>varchar(20)</td>
    <td class="TrOdd" align=Left>null</td>
    <td class="TrOdd" align=Left>Y</td>
    <td class="TrOdd" align=Left>共运行时间</td>
  </tr>
  <tr>
    <td class="TrRows" align=Left>Route</td>
    <td class="TrRows" align=Left>TrainType</td>
    <td class="TrRows" align=Left>nvarchar(20)</td>
    <td class="TrRows" align=Left>null</td>
    <td class="TrRows" align=Left>Y</td>
    <td class="TrRows" align=Left>火车类型</td>
  </tr>
  <tr>
    <td class="TrOdd" align=Left>Route</td>
    <td class="TrOdd" align=Left>StartStation</td>
    <td class="TrOdd" align=Left>nvarchar(20)</td>
    <td class="TrOdd" align=Left>null</td>
    <td class="TrOdd" align=Left>Y</td>
    <td class="TrOdd" align=Left>始发站</td>
  </tr>
  <tr>
    <td class="TrRows" align=Left>Route</td>
    <td class="TrRows" align=Left>EndStation</td>
    <td class="TrRows" align=Left>nvarchar(20)</td>
    <td class="TrRows" align=Left>null</td>
    <td class="TrRows" align=Left>Y</td>
    <td class="TrRows" align=Left>终点站</td>
  </tr>
  
  <tr>
    <td class="TrRows" align=Left></td>
    <td class="TrRows" align=Left></td>
    <td class="TrRows" align=Left></td>
    <td class="TrRows" align=Left></td>
    <td class="TrRows" align=Left></td>
    <td class="TrRows" align=Left></td>
  </tr>

  <tr>
    <td class="TrRows" align=Left>TrainStations</td>
    <td class="TrRows" align=Left>RunTime</td>
    <td class="TrRows" align=Left>varchar(20)</td>
    <td class="TrRows" align=Left>null</td>
    <td class="TrRows" align=Left>Y</td>
    <td class="TrRows" align=Left>运行时间</td>
  </tr>
  <tr>
    <td class="TrOdd" align=Left>TrainStations</td>
    <td class="TrOdd" align=Left>m_yz</td>
    <td class="TrOdd" align=Left>varchar(20)</td>
    <td class="TrOdd" align=Left>null</td>
    <td class="TrOdd" align=Left>Y</td>
    <td class="TrOdd" align=Left>硬座价格</td>
  </tr>
  <tr>
    <td class="TrRows" align=Left>TrainStations</td>
    <td class="TrRows" align=Left>m_rz</td>
    <td class="TrRows" align=Left>varchar(20)</td>
    <td class="TrRows" align=Left>null</td>
    <td class="TrRows" align=Left>Y</td>
    <td class="TrRows" align=Left>软座价格</td>
  </tr>
  <tr>
    <td class="TrOdd" align=Left>TrainStations</td>
    <td class="TrOdd" align=Left>m_yw</td>
    <td class="TrOdd" align=Left>varchar(20)</td>
    <td class="TrOdd" align=Left>null</td>
    <td class="TrOdd" align=Left>Y</td>
    <td class="TrOdd" align=Left>硬卧价格</td>
  </tr>
  <tr>
    <td class="TrRows" align=Left>TrainStations</td>
    <td class="TrRows" align=Left>m_rw</td>
    <td class="TrRows" align=Left>varchar(20)</td>
    <td class="TrRows" align=Left>null</td>
    <td class="TrRows" align=Left>Y</td>
    <td class="TrRows" align=Left>软卧价格</td>
  </tr>
  <tr>
    <td class="TrOdd" align=Left>TrainStations</td>
    <td class="TrOdd" align=Left>LineID</td>
    <td class="TrOdd" align=Left>int</td>
    <td class="TrOdd" align=Left>null</td>
    <td class="TrOdd" align=Left>N</td>
    <td class="TrOdd" align=Left>null</td>
  </tr>
  <tr>
    <td class="TrRows" align=Left>TrainStations</td>
    <td class="TrRows" align=Left>Mileage</td>
    <td class="TrRows" align=Left>int</td>
    <td class="TrRows" align=Left>null</td>
    <td class="TrRows" align=Left>Y</td>
    <td class="TrRows" align=Left>里程</td>
  </tr>
  <tr>
    <td class="TrOdd" align=Left>TrainStations</td>
    <td class="TrOdd" align=Left>Position</td>
    <td class="TrOdd" align=Left>int</td>
    <td class="TrOdd" align=Left>null</td>
    <td class="TrOdd" align=Left>Y</td>
    <td class="TrOdd" align=Left>第几站</td>
  </tr>
  <tr>
    <td class="TrRows" align=Left>TrainStations</td>
    <td class="TrRows" align=Left>Station</td>
    <td class="TrRows" align=Left>nvarchar(50)</td>
    <td class="TrRows" align=Left>null</td>
    <td class="TrRows" align=Left>N</td>
    <td class="TrRows" align=Left>站名</td>
  </tr>
  <tr>
    <td class="TrOdd" align=Left>TrainStations</td>
    <td class="TrOdd" align=Left>TrainNumber</td>
    <td class="TrOdd" align=Left>varchar(50)</td>
    <td class="TrOdd" align=Left>null</td>
    <td class="TrOdd" align=Left>N</td>
    <td class="TrOdd" align=Left>车次</td>
  </tr>
  <tr>
    <td class="TrRows" align=Left>TrainStations</td>
    <td class="TrRows" align=Left>StartTime</td>
    <td class="TrRows" align=Left>varchar(20)</td>
    <td class="TrRows" align=Left>null</td>
    <td class="TrRows" align=Left>Y</td>
    <td class="TrRows" align=Left>开车时间</td>
  </tr>
  <tr>
    <td class="TrOdd" align=Left>TrainStations</td>
    <td class="TrOdd" align=Left>EndTime</td>
    <td class="TrOdd" align=Left>varchar(20)</td>
    <td class="TrOdd" align=Left>null</td>
    <td class="TrOdd" align=Left>Y</td>
    <td class="TrOdd" align=Left>到站时间</td>
  </tr>
  <tr>
    <td class="TrRows" align=Left>TrainStations</td>
    <td class="TrRows" align=Left>StopTime</td>
    <td class="TrRows" align=Left>varchar(20)</td>
    <td class="TrRows" align=Left>null</td>
    <td class="TrRows" align=Left>Y</td>
    <td class="TrRows" align=Left>停车时间</td>
  </tr>
  <tr>
    <td class="TrOdd" align=Left>TrainStations</td>
    <td class="TrOdd" align=Left>ShortCode</td>
    <td class="TrOdd" align=Left>char(10)</td>
    <td class="TrOdd" align=Left>null</td>
    <td class="TrOdd" align=Left>Y</td>
    <td class="TrOdd" align=Left>车站简写</td>
  </tr>
  <tr>
    <td class="TrRows" align=Left>TT_AccountInfo</td>
    <td class="TrRows" align=Left>AccountCode</td>
    <td class="TrRows" align=Left>varchar(50)</td>
    <td class="TrRows" align=Left>null</td>
    <td class="TrRows" align=Left>Y</td>
    <td class="TrRows" align=Left>第三方支付系统帐号</td>
  </tr>
  <tr>
    <td class="TrOdd" align=Left>TT_AccountInfo</td>
    <td class="TrOdd" align=Left>AccountID</td>
    <td class="TrOdd" align=Left>int</td>
    <td class="TrOdd" align=Left>null</td>
    <td class="TrOdd" align=Left>N</td>
    <td class="TrOdd" align=Left>null</td>
  </tr>
  <tr>
    <td class="TrRows" align=Left>TT_AccountInfo</td>
    <td class="TrRows" align=Left>AgentID</td>
    <td class="TrRows" align=Left>int</td>
    <td class="TrRows" align=Left>null</td>
    <td class="TrRows" align=Left>Y</td>
    <td class="TrRows" align=Left>null</td>
  </tr>
  <tr>
    <td class="TrOdd" align=Left>TT_AccountInfo</td>
    <td class="TrOdd" align=Left>CreateOn</td>
    <td class="TrOdd" align=Left>datetime</td>
    <td class="TrOdd" align=Left>(getdate())</td>
    <td class="TrOdd" align=Left>Y</td>
    <td class="TrOdd" align=Left>创建时间</td>
  </tr>
  <tr>
    <td class="TrRows" align=Left>TT_AccountInfo</td>
    <td class="TrRows" align=Left>AccountType</td>
    <td class="TrRows" align=Left>nchar(10)</td>
    <td class="TrRows" align=Left>null</td>
    <td class="TrRows" align=Left>Y</td>
    <td class="TrRows" align=Left>帐户类型(支付宝|财付通)</td>
  </tr>
  <tr>
    <td class="TrOdd" align=Left>TT_Agent</td>
    <td class="TrOdd" align=Left>AgentID</td>
    <td class="TrOdd" align=Left>int</td>
    <td class="TrOdd" align=Left>null</td>
    <td class="TrOdd" align=Left>N</td>
    <td class="TrOdd" align=Left>null</td>
  </tr>
  <tr>
    <td class="TrRows" align=Left>TT_Agent</td>
    <td class="TrRows" align=Left>CreateOn</td>
    <td class="TrRows" align=Left>datetime</td>
    <td class="TrRows" align=Left>(getdate())</td>
    <td class="TrRows" align=Left>N</td>
    <td class="TrRows" align=Left>null</td>
  </tr>
  <tr>
    <td class="TrOdd" align=Left>TT_Agent</td>
    <td class="TrOdd" align=Left>Password</td>
    <td class="TrOdd" align=Left>varchar(50)</td>
    <td class="TrOdd" align=Left>null</td>
    <td class="TrOdd" align=Left>Y</td>
    <td class="TrOdd" align=Left>加密后的密码</td>
  </tr>
  <tr>
    <td class="TrRows" align=Left>TT_Agent</td>
    <td class="TrRows" align=Left>City</td>
    <td class="TrRows" align=Left>varchar(50)</td>
    <td class="TrRows" align=Left>null</td>
    <td class="TrRows" align=Left>N</td>
    <td class="TrRows" align=Left>城市</td>
  </tr>
  <tr>
    <td class="TrOdd" align=Left>TT_Agent</td>
    <td class="TrOdd" align=Left>Telphone</td>
    <td class="TrOdd" align=Left>varchar(100)</td>
    <td class="TrOdd" align=Left>null</td>
    <td class="TrOdd" align=Left>N</td>
    <td class="TrOdd" align=Left>联系电话</td>
  </tr>
  <tr>
    <td class="TrRows" align=Left>TT_Agent</td>
    <td class="TrRows" align=Left>LoginName</td>
    <td class="TrRows" align=Left>varchar(50)</td>
    <td class="TrRows" align=Left>null</td>
    <td class="TrRows" align=Left>N</td>
    <td class="TrRows" align=Left>登录ID</td>
  </tr>
  <tr>
    <td class="TrOdd" align=Left>TT_Agent</td>
    <td class="TrOdd" align=Left>Address</td>
    <td class="TrOdd" align=Left>nvarchar(200)</td>
    <td class="TrOdd" align=Left>null</td>
    <td class="TrOdd" align=Left>N</td>
    <td class="TrOdd" align=Left>地址</td>
  </tr>
  <tr>
    <td class="TrRows" align=Left>TT_Agent</td>
    <td class="TrRows" align=Left>Nearby</td>
    <td class="TrRows" align=Left>nvarchar(50)</td>
    <td class="TrRows" align=Left>null</td>
    <td class="TrRows" align=Left>Y</td>
    <td class="TrRows" align=Left>靠近那儿</td>
  </tr>
  <tr>
    <td class="TrOdd" align=Left>TT_Agent</td>
    <td class="TrOdd" align=Left>AgentName</td>
    <td class="TrOdd" align=Left>nchar(20)</td>
    <td class="TrOdd" align=Left>null</td>
    <td class="TrOdd" align=Left>N</td>
    <td class="TrOdd" align=Left>售票点名称</td>
  </tr>
  <tr>
    <td class="TrRows" align=Left>TT_Agent</td>
    <td class="TrRows" align=Left>Linkman</td>
    <td class="TrRows" align=Left>nchar(20)</td>
    <td class="TrRows" align=Left>null</td>
    <td class="TrRows" align=Left>N</td>
    <td class="TrRows" align=Left>联系人</td>
  </tr>
  <tr>
    <td class="TrOdd" align=Left>TT_Orders</td>
    <td class="TrOdd" align=Left>UserTelphone</td>
    <td class="TrOdd" align=Left>char(50)</td>
    <td class="TrOdd" align=Left>null</td>
    <td class="TrOdd" align=Left>Y</td>
    <td class="TrOdd" align=Left>买票人电话</td>
  </tr>
  <tr>
    <td class="TrRows" align=Left>TT_Orders</td>
    <td class="TrRows" align=Left>IsCHD</td>
    <td class="TrRows" align=Left>bit</td>
    <td class="TrRows" align=Left>((0))</td>
    <td class="TrRows" align=Left>Y</td>
    <td class="TrRows" align=Left>是否为</td>
  </tr>
  <tr>
    <td class="TrOdd" align=Left>TT_Orders</td>
    <td class="TrOdd" align=Left>OrderNum</td>
    <td class="TrOdd" align=Left>varchar(20)</td>
    <td class="TrOdd" align=Left>null</td>
    <td class="TrOdd" align=Left>N</td>
    <td class="TrOdd" align=Left>订单号</td>
  </tr>
  <tr>
    <td class="TrRows" align=Left>TT_Orders</td>
    <td class="TrRows" align=Left>TrainNumber</td>
    <td class="TrRows" align=Left>varchar(50)</td>
    <td class="TrRows" align=Left>null</td>
    <td class="TrRows" align=Left>Y</td>
    <td class="TrRows" align=Left>车次</td>
  </tr>
  <tr>
    <td class="TrOdd" align=Left>TT_Orders</td>
    <td class="TrOdd" align=Left>OrderID</td>
    <td class="TrOdd" align=Left>int</td>
    <td class="TrOdd" align=Left>null</td>
    <td class="TrOdd" align=Left>N</td>
    <td class="TrOdd" align=Left>订单标识</td>
  </tr>
  <tr>
    <td class="TrRows" align=Left>TT_Orders</td>
    <td class="TrRows" align=Left>UserID</td>
    <td class="TrRows" align=Left>int</td>
    <td class="TrRows" align=Left>null</td>
    <td class="TrRows" align=Left>Y</td>
    <td class="TrRows" align=Left>null</td>
  </tr>
  <tr>
    <td class="TrOdd" align=Left>TT_Orders</td>
    <td class="TrOdd" align=Left>AgentID</td>
    <td class="TrOdd" align=Left>int</td>
    <td class="TrOdd" align=Left>null</td>
    <td class="TrOdd" align=Left>Y</td>
    <td class="TrOdd" align=Left>售票点ID</td>
  </tr>
  <tr>
    <td class="TrRows" align=Left>TT_Orders</td>
    <td class="TrRows" align=Left>Amount</td>
    <td class="TrRows" align=Left>int</td>
    <td class="TrRows" align=Left>((1))</td>
    <td class="TrRows" align=Left>N</td>
    <td class="TrRows" align=Left>张数</td>
  </tr>
  <tr>
    <td class="TrOdd" align=Left>TT_Orders</td>
    <td class="TrOdd" align=Left>TicketDate</td>
    <td class="TrOdd" align=Left>datetime</td>
    <td class="TrOdd" align=Left>null</td>
    <td class="TrOdd" align=Left>Y</td>
    <td class="TrOdd" align=Left>车票日期</td>
  </tr>
  <tr>
    <td class="TrRows" align=Left>TT_Orders</td>
    <td class="TrRows" align=Left>CreateOn</td>
    <td class="TrRows" align=Left>datetime</td>
    <td class="TrRows" align=Left>(getdate())</td>
    <td class="TrRows" align=Left>Y</td>
    <td class="TrRows" align=Left>订单日期</td>
  </tr>
  <tr>
    <td class="TrOdd" align=Left>TT_Orders</td>
    <td class="TrOdd" align=Left>UnitPrice</td>
    <td class="TrOdd" align=Left>money</td>
    <td class="TrOdd" align=Left>null</td>
    <td class="TrOdd" align=Left>N</td>
    <td class="TrOdd" align=Left>单价(票价)</td>
  </tr>
  <tr>
    <td class="TrRows" align=Left>TT_Orders</td>
    <td class="TrRows" align=Left>PayPoundage</td>
    <td class="TrRows" align=Left>money</td>
    <td class="TrRows" align=Left>null</td>
    <td class="TrRows" align=Left>Y</td>
    <td class="TrRows" align=Left>支付手续费</td>
  </tr>
  <tr>
    <td class="TrOdd" align=Left>TT_Orders</td>
    <td class="TrOdd" align=Left>TotalMoney</td>
    <td class="TrOdd" align=Left>money</td>
    <td class="TrOdd" align=Left>null</td>
    <td class="TrOdd" align=Left>N</td>
    <td class="TrOdd" align=Left>共计多少钱</td>
  </tr>
  <tr>
    <td class="TrRows" align=Left>TT_Orders</td>
    <td class="TrRows" align=Left>PayMoney</td>
    <td class="TrRows" align=Left>money</td>
    <td class="TrRows" align=Left>null</td>
    <td class="TrRows" align=Left>N</td>
    <td class="TrRows" align=Left>实际支付金额</td>
  </tr>
  <tr>
    <td class="TrOdd" align=Left>TT_Orders</td>
    <td class="TrOdd" align=Left>StartStation</td>
    <td class="TrOdd" align=Left>nchar(50)</td>
    <td class="TrOdd" align=Left>null</td>
    <td class="TrOdd" align=Left>Y</td>
    <td class="TrOdd" align=Left>始发站</td>
  </tr>
  <tr>
    <td class="TrRows" align=Left>TT_Orders</td>
    <td class="TrRows" align=Left>EndStation</td>
    <td class="TrRows" align=Left>nchar(10)</td>
    <td class="TrRows" align=Left>null</td>
    <td class="TrRows" align=Left>Y</td>
    <td class="TrRows" align=Left>到达站</td>
  </tr>
  <tr>
    <td class="TrOdd" align=Left>TT_Orders</td>
    <td class="TrOdd" align=Left>UserName</td>
    <td class="TrOdd" align=Left>nchar(30)</td>
    <td class="TrOdd" align=Left>null</td>
    <td class="TrOdd" align=Left>Y</td>
    <td class="TrOdd" align=Left>买票人</td>
  </tr>
  <tr>
    <td class="TrRows" align=Left>TT_Orders</td>
    <td class="TrRows" align=Left>Pew</td>
    <td class="TrRows" align=Left>nchar(20)</td>
    <td class="TrRows" align=Left>(N'不限')</td>
    <td class="TrRows" align=Left>Y</td>
    <td class="TrRows" align=Left>座席</td>
  </tr>
  <tr>
    <td class="TrOdd" align=Left>TT_PushFee</td>
    <td class="TrOdd" align=Left>Dec</td>
    <td class="TrOdd" align=Left>nvarchar(100)</td>
    <td class="TrOdd" align=Left>null</td>
    <td class="TrOdd" align=Left>Y</td>
    <td class="TrOdd" align=Left>描述</td>
  </tr>
  <tr>
    <td class="TrRows" align=Left>TT_PushFee</td>
    <td class="TrRows" align=Left>CreateOn</td>
    <td class="TrRows" align=Left>datetime</td>
    <td class="TrRows" align=Left>null</td>
    <td class="TrRows" align=Left>Y</td>
    <td class="TrRows" align=Left>null</td>
  </tr>
  <tr>
    <td class="TrOdd" align=Left>TT_PushFee</td>
    <td class="TrOdd" align=Left>OtherAccount</td>
    <td class="TrOdd" align=Left>varbinary(50)</td>
    <td class="TrOdd" align=Left>null</td>
    <td class="TrOdd" align=Left>Y</td>
    <td class="TrOdd" align=Left>其他帐户</td>
  </tr>
  <tr>
    <td class="TrRows" align=Left>TT_PushFee</td>
    <td class="TrRows" align=Left>NPAY</td>
    <td class="TrRows" align=Left>varchar(50)</td>
    <td class="TrRows" align=Left>null</td>
    <td class="TrRows" align=Left>Y</td>
    <td class="TrRows" align=Left>第三方支付平台名称</td>
  </tr>
  <tr>
    <td class="TrOdd" align=Left>TT_PushFee</td>
    <td class="TrOdd" align=Left>AgentAccount</td>
    <td class="TrOdd" align=Left>varchar(50)</td>
    <td class="TrOdd" align=Left>null</td>
    <td class="TrOdd" align=Left>N</td>
    <td class="TrOdd" align=Left>存入帐户</td>
  </tr>
  <tr>
    <td class="TrRows" align=Left>TT_PushFee</td>
    <td class="TrRows" align=Left>PlatformAccount</td>
    <td class="TrRows" align=Left>varchar(50)</td>
    <td class="TrRows" align=Left>null</td>
    <td class="TrRows" align=Left>N</td>
    <td class="TrRows" align=Left>null</td>
  </tr>
  <tr>
    <td class="TrOdd" align=Left>TT_PushFee</td>
    <td class="TrOdd" align=Left>OrderID</td>
    <td class="TrOdd" align=Left>int</td>
    <td class="TrOdd" align=Left>null</td>
    <td class="TrOdd" align=Left>N</td>
    <td class="TrOdd" align=Left>null</td>
  </tr>
  <tr>
    <td class="TrRows" align=Left>TT_PushFee</td>
    <td class="TrRows" align=Left>AgentGet</td>
    <td class="TrRows" align=Left>money</td>
    <td class="TrRows" align=Left>null</td>
    <td class="TrRows" align=Left>N</td>
    <td class="TrRows" align=Left>代理商分账金额</td>
  </tr>
  <tr>
    <td class="TrOdd" align=Left>TT_PushFee</td>
    <td class="TrOdd" align=Left>PlatformGet</td>
    <td class="TrOdd" align=Left>money</td>
    <td class="TrOdd" align=Left>null</td>
    <td class="TrOdd" align=Left>N</td>
    <td class="TrOdd" align=Left>平台分账金额</td>
  </tr>
  <tr>
    <td class="TrRows" align=Left>TT_PushFee</td>
    <td class="TrRows" align=Left>OtherGet</td>
    <td class="TrRows" align=Left>money</td>
    <td class="TrRows" align=Left>null</td>
    <td class="TrRows" align=Left>Y</td>
    <td class="TrRows" align=Left>其他分账金额</td>
  </tr>
  <tr>
    <td class="TrOdd" align=Left>TT_Trade</td>
    <td class="TrOdd" align=Left>PayAmount</td>
    <td class="TrOdd" align=Left>money</td>
    <td class="TrOdd" align=Left>null</td>
    <td class="TrOdd" align=Left>Y</td>
    <td class="TrOdd" align=Left>支付金额</td>
  </tr>
  <tr>
    <td class="TrRows" align=Left>TT_Trade</td>
    <td class="TrRows" align=Left>OrderID</td>
    <td class="TrRows" align=Left>int</td>
    <td class="TrRows" align=Left>null</td>
    <td class="TrRows" align=Left>Y</td>
    <td class="TrRows" align=Left>订单标识</td>
  </tr>
  <tr>
    <td class="TrOdd" align=Left>TT_Trade</td>
    <td class="TrOdd" align=Left>OrderNumber</td>
    <td class="TrOdd" align=Left>varchar(64)</td>
    <td class="TrOdd" align=Left>null</td>
    <td class="TrOdd" align=Left>Y</td>
    <td class="TrOdd" align=Left>订单号</td>
  </tr>
  <tr>
    <td class="TrRows" align=Left>TT_Trade</td>
    <td class="TrRows" align=Left>BuyerID</td>
    <td class="TrRows" align=Left>varchar(30)</td>
    <td class="TrRows" align=Left>null</td>
    <td class="TrRows" align=Left>Y</td>
    <td class="TrRows" align=Left>买家ID</td>
  </tr>
  <tr>
    <td class="TrOdd" align=Left>TT_Trade</td>
    <td class="TrOdd" align=Left>BuyerEmail</td>
    <td class="TrOdd" align=Left>varchar(100)</td>
    <td class="TrOdd" align=Left>null</td>
    <td class="TrOdd" align=Left>Y</td>
    <td class="TrOdd" align=Left>买家EMAIL</td>
  </tr>
  <tr>
    <td class="TrRows" align=Left>TT_Trade</td>
    <td class="TrRows" align=Left>SellerID</td>
    <td class="TrRows" align=Left>varchar(30)</td>
    <td class="TrRows" align=Left>null</td>
    <td class="TrRows" align=Left>Y</td>
    <td class="TrRows" align=Left>卖家ID</td>
  </tr>
  <tr>
    <td class="TrOdd" align=Left>TT_Trade</td>
    <td class="TrOdd" align=Left>SellerEmail</td>
    <td class="TrOdd" align=Left>varchar(100)</td>
    <td class="TrOdd" align=Left>null</td>
    <td class="TrOdd" align=Left>Y</td>
    <td class="TrOdd" align=Left>卖家EMAIL</td>
  </tr>
  <tr>
    <td class="TrRows" align=Left>TT_Trade</td>
    <td class="TrRows" align=Left>IsPaid</td>
    <td class="TrRows" align=Left>bit</td>
    <td class="TrRows" align=Left>((0))</td>
    <td class="TrRows" align=Left>N</td>
    <td class="TrRows" align=Left>是否成功支付</td>
  </tr>
  <tr>
    <td class="TrOdd" align=Left>TT_Trade</td>
    <td class="TrOdd" align=Left>CreateOn</td>
    <td class="TrOdd" align=Left>datetime</td>
    <td class="TrOdd" align=Left>(getdate())</td>
    <td class="TrOdd" align=Left>Y</td>
    <td class="TrOdd" align=Left>创建时间</td>
  </tr>
  <tr>
    <td class="TrRows" align=Left>TT_Trade</td>
    <td class="TrRows" align=Left>TradeNo</td>
    <td class="TrRows" align=Left>varchar(64)</td>
    <td class="TrRows" align=Left>null</td>
    <td class="TrRows" align=Left>Y</td>
    <td class="TrRows" align=Left>该交易在第三方支付系统中的交易流水号</td>
  </tr>
  <tr>
    <td class="TrOdd" align=Left>TT_Travler</td>
    <td class="TrOdd" align=Left>UserID</td>
    <td class="TrOdd" align=Left>int</td>
    <td class="TrOdd" align=Left>null</td>
    <td class="TrOdd" align=Left>N</td>
    <td class="TrOdd" align=Left>null</td>
  </tr>
  <tr>
    <td class="TrRows" align=Left>TT_Travler</td>
    <td class="TrRows" align=Left>UserName</td>
    <td class="TrRows" align=Left>varchar(50)</td>
    <td class="TrRows" align=Left>null</td>
    <td class="TrRows" align=Left>Y</td>
    <td class="TrRows" align=Left>名字</td>
  </tr>
  <tr>
    <td class="TrOdd" align=Left>TT_Travler</td>
    <td class="TrOdd" align=Left>Email</td>
    <td class="TrOdd" align=Left>varchar(50)</td>
    <td class="TrOdd" align=Left>null</td>
    <td class="TrOdd" align=Left>Y</td>
    <td class="TrOdd" align=Left>旅客Email</td>
  </tr>
  <tr>
    <td class="TrRows" align=Left>TT_Travler</td>
    <td class="TrRows" align=Left>TelPhone</td>
    <td class="TrRows" align=Left>varchar(20)</td>
    <td class="TrRows" align=Left>null</td>
    <td class="TrRows" align=Left>N</td>
    <td class="TrRows" align=Left>联系电话</td>
  </tr>
  <tr>
    <td class="TrOdd" align=Left>TT_Travler</td>
    <td class="TrOdd" align=Left>IsChecked</td>
    <td class="TrOdd" align=Left>bit</td>
    <td class="TrOdd" align=Left>((0))</td>
    <td class="TrOdd" align=Left>Y</td>
    <td class="TrOdd" align=Left>电话是否被验证</td>
  </tr>
</Table>
</BODY>
</HTML>
